package com.school.dao;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.school.entity.HljtClass;
import com.school.entity.HljtTeacher;
import com.school.entity.web.TeacherCurriculumInfo;


@Repository
public interface HljtTeacherCurriculumoDao {

	
	List<HljtTeacher> findAllTacherInfo(int nType);
	
	List<HljtClass> findAllClasses();
	
	List<TeacherCurriculumInfo> findHCurriculumInfo(int nType,int pageIndex,int pageSize);
	
	List<TeacherCurriculumInfo> findHCurriculumInfoByName(int nType,String name,int pageIndex,int pageSize);
	
	List<TeacherCurriculumInfo> findCurriculumInfo();
	
	List<TeacherCurriculumInfo> findCurriculumInfoByName(String name);
	
	int findHCurriculumInfoCount(int nType);
	
	int findCurriculumInfoCount();
	
	int findHCurriculumInfoCountByName(int nType,String name);
	
	int findCurriculumInfoCountByName(String name);
	
	int selectCountByTeacherIdAndType(int teacherId);
	
	int	selectCountByTeacherId(int teacherId);
	
	int selectCountByClassIdAndType(int classId);
	
	int selectCurriculumInfoByTeacherIdAndClassId(int classId,int teacherId);
	
	String selectCurriculumInfoByTeacherIdAndType(int nType,int teacherId);
	
	String selectSubjectByTeacherId(int teacherId);
	
	List<Integer> selectClassesByTeacherId(int teacherId);
	
	int insertTeacherCurriculumInfoList(List<TeacherCurriculumInfo> oList);
	
	List<TeacherCurriculumInfo> selectTeacherCurriculumInfoList(List<Integer> tList);
	
	List<TeacherCurriculumInfo> selectTeacherCurriculumInfoByTeacherId(int teacherId );
	
	int insertTeacherCurriculumInfo(TeacherCurriculumInfo oTeacherCurriculumInfo);
	
	int updateTeacherTypeToZero(int oldClassIds,int oldTeacherId);
	
	int updateTeacherTypeToOne(int classId,int teacherId,String subject);
	
	int updateCurriculumInfoByOld(int oldClassIds,int oldTeacherId,int classIds,int teacherId,String subject);
	
	//删除任课老师 课程关联
	void deleteCurrculumInfo(List<Integer> IdI);
	//删除班主任 课程关联
	int deleteHoCurrculumInfo(TeacherCurriculumInfo oTeacherCurriculumInfo);
}
